Tabela Contract

Definicja tabeli Contract

Name

Contract

Code

Contract

Comment

PL: Dane umowy
m.in. kontrakt na benefit plany.
Inaczej Umowa.
EN: Contract data


Lista kolumn tabeli Contract

Name

Code

ContractID

ContractID

ActivationWayID

ActivationWayID

ContractTypeID

ContractTypeID

ContractSubjectID

ContractSubjectID

SalesCenterID

SalesCenterID

ContractorID

ContractorID

DetailedContrSubjectID

DetailedContrSubjectID

ContractNo

ContractNo

Description

Description

ClientName

ClientName

DebtorNo

DebtorNo

StartDT

StartDT

StopDT

StopDT

ActivationDT

ActivationDT

SignDT

SignDT

CancelDT

CancelDT

ExpireDT

ExpireDT

Comments

Comments

Active

Active

Notes

Notes

ReportInfo

ReportInfo

Calculation

Calculation

ExternalContractNo

ExternalContractNo

AllUserAccess

AllUserAccess

AlternativeContractNo

AlternativeContractNo

QualificationLevelCode

QualificationLevelCode

QualificationLevelStartDT

QualificationLevelStartDT

QualificationLevelStopDT

QualificationLevelStopDT


Kolumna ContractID tabeli Contract

Definicja kolumny ContractID tabeli Contract

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID umowy


Kolumna ActivationWayID tabeli Contract

Definicja kolumny ActivationWayID tabeli Contract

Name

ActivationWayID

Code

ActivationWayID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractTypeID tabeli Contract

Definicja kolumny ContractTypeID tabeli Contract

Name

ContractTypeID

Code

ContractTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractSubjectID tabeli Contract

Definicja kolumny ContractSubjectID tabeli Contract

Name

ContractSubjectID

Code

ContractSubjectID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SalesCenterID tabeli Contract

Definicja kolumny SalesCenterID tabeli Contract

Name

SalesCenterID

Code

SalesCenterID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractorID tabeli Contract

Definicja kolumny ContractorID tabeli Contract

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DetailedContrSubjectID tabeli Contract

Definicja kolumny DetailedContrSubjectID tabeli Contract

Name

DetailedContrSubjectID

Code

DetailedContrSubjectID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID szczególowego przedmiotu umowy


Kolumna ContractNo tabeli Contract

Definicja kolumny ContractNo tabeli Contract

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna Description tabeli Contract

Definicja kolumny Description tabeli Contract

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna ClientName tabeli Contract

Definicja kolumny ClientName tabeli Contract

Name

ClientName

Code

ClientName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna DebtorNo tabeli Contract

Definicja kolumny DebtorNo tabeli Contract

Name

DebtorNo

Code

DebtorNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Contract

Definicja kolumny StartDT tabeli Contract

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Contract

Definicja kolumny StopDT tabeli Contract

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna ActivationDT tabeli Contract

Definicja kolumny ActivationDT tabeli Contract

Name

ActivationDT

Code

ActivationDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SignDT tabeli Contract

Definicja kolumny SignDT tabeli Contract

Name

SignDT

Code

SignDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna CancelDT tabeli Contract

Definicja kolumny CancelDT tabeli Contract

Name

CancelDT

Code

CancelDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ExpireDT tabeli Contract

Definicja kolumny ExpireDT tabeli Contract

Name

ExpireDT

Code

ExpireDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Comments tabeli Contract

Definicja kolumny Comments tabeli Contract

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Active tabeli Contract

Definicja kolumny Active tabeli Contract

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Notes tabeli Contract

Definicja kolumny Notes tabeli Contract

Name

Notes

Code

Notes

Data Type

VARCHAR2(2048)

Mandatory

No

Comment

 


Kolumna ReportInfo tabeli Contract

Definicja kolumny ReportInfo tabeli Contract

Name

ReportInfo

Code

ReportInfo

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna Calculation tabeli Contract

Definicja kolumny Calculation tabeli Contract

Name

Calculation

Code

Calculation

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ExternalContractNo tabeli Contract

Definicja kolumny ExternalContractNo tabeli Contract

Name

ExternalContractNo

Code

ExternalContractNo

Data Type

VARCHAR2(48)

Mandatory

No

Comment

Pole na potrzeby MSWiA, do zapisania zewnetrznego numeru
umowy.


Kolumna AllUserAccess tabeli Contract

Definicja kolumny AllUserAccess tabeli Contract

Name

AllUserAccess

Code

AllUserAccess

Data Type

NUMBER(5)

Mandatory

No

Comment

Okresla (1,0) czy umowa jest dostepna dla wszystkich uzytkowników


Kolumna AlternativeContractNo tabeli Contract

Definicja kolumny AlternativeContractNo tabeli Contract

Name

AlternativeContractNo

Code

AlternativeContractNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Oryginalny numer umowy która otrzymuje szpital np. z NFZ-tu


Kolumna QualificationLevelCode tabeli Contract

Definicja kolumny QualificationLevelCode tabeli Contract

Name

QualificationLevelCode

Code

QualificationLevelCode

Data Type

VARCHAR2(10)

Mandatory

No

Comment

kod kwalifikacji do sieci szpitali


Kolumna QualificationLevelStartDT tabeli Contract

Definicja kolumny QualificationLevelStartDT tabeli Contract

Name

QualificationLevelStartDT

Code

QualificationLevelStartDT

Data Type

DATE

Mandatory

No

Comment

data poczatku waznosci kwalifikacji


Kolumna QualificationLevelStopDT tabeli Contract

Definicja kolumny QualificationLevelStopDT tabeli Contract

Name

QualificationLevelStopDT

Code

QualificationLevelStopDT

Data Type

DATE

Mandatory

No

Comment

data konca waznosci kwalifikacji


Lista kluczy tabeli Contract

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Contract

Definicja klucza Identifier_1 tabeli Contract

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment